Quarry: Digging Up the Gems of Your Data Treasury
نویسندگان
چکیده
The design lifecycle of a data warehousing (DW) system is primarily led by requirements of its end-users and the complexity of underlying data sources. The process of designing a multidimensional (MD) schema and back-end extracttransform-load (ETL) processes, is a long-term and mostly manual task. As enterprises shift to more real-time and ’onthe-fly’ decision making, business intelligence (BI) systems require automated means for efficiently adapting a physical DW design to frequent changes of business needs. To address this problem, we present Quarry, an end-to-end system for assisting users of various technical skills in managing the incremental design and deployment of MD schemata and ETL processes. Quarry automates the physical design of a DW system from high-level information requirements. Moreover, Quarry provides tools for efficiently accommodating MD schema and ETL process designs to new or changed information needs of its end-users. Finally, Quarry facilitates the deployment of the generated DW design over an extensible list of execution engines. On-site, we will use a variety of examples to show how Quarry facilitates the complexity of the DW design lifecycle.
منابع مشابه
Genome-Scale Metabolic Network Models of Bacillus Species Suggest that Model Improvement is Necessary for Biotechnological Applications
Background: A genome-scale metabolic network model (GEM) is a mathematical representation of an organism’s metabolism. Today, GEMs are popular tools for computationally simulating the biotechnological processes and for predicting biochemical properties of (engineered) strains.Objectives: In the present study, we have evaluated the predictive power of two ...
متن کاملModeling and Optimization of Truck-Shovel Allocation to Mining Faces in Cement Quarry
Truck and shovel are the most common raw material transportation system used in the cement quarry operations. One of the major challenges associated with the cement quarry operations is the efficient allocation of truck and shovel to the mining faces. In order to minimize the truck and shovel operating cost, subject to quantity and quality constraints, the mixed integer linear programing (MILP)...
متن کاملA Study of Artistic and Symbolic Features in Five Royal Qajar Aigrettes in the National Treasury of Iran
The Iranian kings have valued jewels and ornaments greatly and any king has attempted to collect the best ornaments and jewels entrusting them to professional craftsmen to enable kings by this way to increase their imperial glory socially and economically. It was also thought that more ornaments mean a great and glorious kingdom. Therefore, different Iranian kings have collected a tremendous tr...
متن کاملThe role of "memory" (treasury of meaning) and "imagination" (treasury of face) of the architect in shaping the process of creating and perceiving architectural works based on the view of transcendent wisdom
The issue of how the process of creating and perceiving architectural works and the factors affecting it is an important, multidimensional and interdisciplinary category. However, at present, the process of formation of architectural works in most studies is based on superficial perceptions of human perception and at best depends on the five human senses and, of course, usually limited to some ...
متن کامل